{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Employees","Administration","Development","Production","Sales","Employee Totals","Sheet6","Sheet7","Sheet8"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Employees","index":0,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"Worldwide Sporting Goods",null,null,null,null,null,null,null,"Departments","Administration"]
[null,"Employee Information",null,null,null,null,null,null,null,null,"Development"]
[null,null,null,null,null,null,null,null,null,null,"Production"]
[null,null,null,null,null,null,null,null,null,null,"Sales"]
["Test","Last Name","First Name","Hire Date","Department","Status","Salary","Raise"]
[{"$f":"IF(E6=\"Sales\",\"\",E6)","v":"Administration"},"Baker","Amy","1988-07-28","Administration",4,19000,{"$f":"+G6*0.035","v":665.00000000000011}]
[{"$f":"IF(E7=\"Sales\",\"\",E7)","v":"Administration"},"Baker","Christine","1986-05-09","Administration",4,22000,{"$f":"+G7*0.035","v":770.00000000000011}]
[{"$f":"IF(E8=\"Sales\",\"\",E8)","v":"Administration"},"Adelheim","John","1988-11-18","Administration",2,23000,{"$f":"+G8*0.035","v":805.00000000000011}]
[{"$f":"IF(E9=\"Sales\",\"\",E9)","v":"Administration"},"Johnson","Jon","1982-01-10","Administration",3,25000,{"$f":"+G9*0.035","v":875.00000000000011}]
[{"$f":"IF(E10=\"Sales\",\"\",E10)","v":"Administration"},"Eastburn","George","1998-06-17","Administration",3,50000,{"$f":"+G10*0.035","v":1750.0000000000002}]
[{"$f":"IF(E11=\"Sales\",\"\",E11)","v":"Development"},"Deibler","Karl","1990-09-22","Development",2,24000,{"$f":"+G11*0.035","v":840.00000000000011}]
[{"$f":"IF(E12=\"Sales\",\"\",E12)","v":"Development"},"Bachman","Vance","1997-12-15","Development",7,45000,{"$f":"+G12*0.035","v":1575.0000000000002}]
[{"$f":"IF(E13=\"Sales\",\"\",E13)","v":"Development"},"Callaghan","Ronald","1998-09-22","Development",2,62000,{"$f":"+G13*0.035","v":2170}]
[{"$f":"IF(E14=\"Sales\",\"\",E14)","v":"Production"},"Trimbach","Doug","1968-11-24","Production",2,16000,{"$f":"+G14*0.035","v":560}]
[{"$f":"IF(E15=\"Sales\",\"\",E15)","v":"Production"},"Roy","Audrey","1973-08-17","Production",2,21000,{"$f":"+G15*0.035","v":735.00000000000011}]
[{"$f":"IF(E16=\"Sales\",\"\",E16)","v":"Production"},"Wang","Will","1993-02-27","Production",4,22000,{"$f":"+G16*0.035","v":770.00000000000011}]
[{"$f":"IF(E17=\"Sales\",\"\",E17)","v":"Production"},"Davis","Henry","1993-09-02","Production",2,28000,{"$f":"+G17*0.035","v":980.00000000000011}]
[{"$f":"IF(E18=\"Sales\",\"\",E18)","v":"Production"},"Messick","Steve","1982-01-08","Production",3,28000,{"$f":"+G18*0.035","v":980.00000000000011}]
[{"$f":"IF(E19=\"Sales\",\"\",E19)","v":"Production"},"Deal","Laura","1995-05-17","Production",2,30000,{"$f":"+G19*0.035","v":1050}]
[{"$f":"IF(E20=\"Sales\",\"\",E20)","v":"Production"},"Sticklebaugh","Wendy","1978-06-24","Production",3,32000,{"$f":"+G20*0.035","v":1120}]
[{"$f":"IF(E21=\"Sales\",\"\",E21)","v":"Production"},"Fimbel","Josephine","1997-09-22","Production",2,40000,{"$f":"+G21*0.035","v":1400.0000000000002}]
[{"$f":"IF(E22=\"Sales\",\"\",E22)","v":"Production"},"Fredericks","Miller","1978-10-05","Production",3,40000,{"$f":"+G22*0.035","v":1400.0000000000002}]
[{"$f":"IF(E23=\"Sales\",\"\",E23)","v":"Production"},"Albrecht","Horst","1997-11-21","Production",2,41000,{"$f":"+G23*0.035","v":1435.0000000000002}]
[{"$f":"IF(E24=\"Sales\",\"\",E24)","v":"Production"},"Parker","Paul","1972-04-05","Production",2,48000,{"$f":"+G24*0.035","v":1680.0000000000002}]
[{"$f":"IF(E25=\"Sales\",\"\",E25)","v":""},"Feldgus","Ernest","1989-11-21","Sales",2,24000,{"$f":"+G25*0.035","v":840.00000000000011}]
[{"$f":"IF(E26=\"Sales\",\"\",E26)","v":""},"Abramas","Alice","1992-11-30","Sales",2,25000,{"$f":"+G26*0.035","v":875.00000000000011}]
[{"$f":"IF(E27=\"Sales\",\"\",E27)","v":""},"Caracio","Terry","1992-04-15","Sales",2,25000,{"$f":"+G27*0.035","v":875.00000000000011}]
[{"$f":"IF(E28=\"Sales\",\"\",E28)","v":""},"Carpenter","John","1993-05-27","Sales",2,26000,{"$f":"+G28*0.035","v":910.00000000000011}]
[{"$f":"IF(E29=\"Sales\",\"\",E29)","v":""},"Faraco","Janice","1993-12-22","Sales",2,29000,{"$f":"+G29*0.035","v":1015.0000000000001}]
[{"$f":"IF(E30=\"Sales\",\"\",E30)","v":""},"Weinstein","Perry","1981-08-31","Sales",3,32000,{"$f":"+G30*0.035","v":1120}]
[{"$f":"IF(E31=\"Sales\",\"\",E31)","v":""},"Edwards","Susan","1996-01-19","Sales",2,37000,{"$f":"+G31*0.035","v":1295.0000000000002}]
[{"$f":"IF(E32=\"Sales\",\"\",E32)","v":""},"Killough","Frank","1983-12-15","Sales",7,45000,{"$f":"+G32*0.035","v":1575.0000000000002}]
[{"$f":"IF(E33=\"Sales\",\"\",E33)","v":""},"Edwards","Fred","1998-09-13","Sales",4,55000,{"$f":"+G33*0.035","v":1925.0000000000002}]

{"sheet":"Administration","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Worldwide Sporting Goods"]
["Employees by Department"]
[]
[]
["Last Name","First Name","Department","Hire Date","Status","Salary","Raise","New Salary"]
["Eastburn","George","Administration","1968-12-22",3,50000,{"$f":"+F6*0.035","v":1750.0000000000002},{"$f":"+F6+G6","v":51750}]
["Adelheim","John","Administration","1987-06-10",2,23000,{"$f":"+F7*0.035","v":805.00000000000011},{"$f":"+F7+G7","v":23805}]
["Baker","Christine","Administration","1995-03-05",4,22000,{"$f":"+F8*0.035","v":770.00000000000011},{"$f":"+F8+G8","v":22770}]
["Baker","Amy","Administration","1995-06-10",4,19000,{"$f":"+F9*0.035","v":665.00000000000011},{"$f":"+F9+G9","v":19665}]
["Johnson","Jon","Administration","1990-05-21",3,25000,{"$f":"+F10*0.035","v":875.00000000000011},{"$f":"+F10+G10","v":25875}]

{"sheet":"Development","index":2,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Worldwide Sporting Goods"]
["Employees by Department"]
[]
[]
["Last Name","First Name","Department","Hire Date","Status","Salary","Raise","New Salary"]
["Callaghan","Ronald","Development","1970-05-05",2,62000,{"$f":"+F6*0.035","v":2170},{"$f":"+F6+G6","v":64170}]
["Bachman","Vance","Development","1990-09-09",7,45000,{"$f":"+F7*0.035","v":1575.0000000000002},{"$f":"+F7+G7","v":46575}]
["Deibler","Karl","Development","1978-09-26",2,24000,{"$f":"+F8*0.035","v":840.00000000000011},{"$f":"+F8+G8","v":24840}]

{"sheet":"Production","index":3,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Worldwide Sporting Goods"]
["Employees by Department"]
[]
[]
["Last Name","First Name","Department","Hire Date","Status","Salary","Raise","New Salary"]
["Albrecht","Horst","Production","1960-11-07",2,41000,{"$f":"+F6*0.035","v":1435.0000000000002},{"$f":"+F6+G6","v":42435}]
["Fimbel","Josephine","Production","1994-06-10",2,40000,1400.0000000000002,41400]
["Deal","Laura","Production","1985-04-15",2,30000,1050,31050]
["Davis","Henry","Production","1992-10-06",2,28000,980.00000000000011,28980]
["Messick","Steve","Production","1989-01-01",3,28000,980.00000000000011,28980]
["Fredericks","Miller","Production","1992-02-02",3,40000,1400.0000000000002,41400]
["Sticklebaugh","Wendy","Production","1978-05-19",3,32000,1120,33120]
["Roy","Audrey","Production","1994-09-02",2,21000,735.00000000000011,21735]
["Parker","Paul","Production","1986-08-09",2,48000,1680.0000000000002,49680]
["Trimbach","Doug","Production","1995-06-01",2,16000,560,16560]
["Wang","Will","Production","1975-06-23",4,22000,770.00000000000011,22770]

{"sheet":"Sales","index":4,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Worldwide Sporting Goods"]
["Employees by Department"]
[]
[]
["Last Name","First Name","Department","Hire Date","Status","Salary","Raise","New Salary"]
["Edwards","Fred","Sales","1965-08-12",4,55000,{"$f":"+F6*0.035","v":1925.0000000000002},{"$f":"+F6+G6","v":56925}]
["Edwards","Susan","Sales","1983-01-25",2,37000,1295.0000000000002,38295]
["Faraco","Janice","Sales","1989-08-18",2,29000,1015.0000000000001,30015]
["Carpenter","John","Sales","1990-02-12",2,26000,910.00000000000011,26910]
["Abramas","Alice","Sales","1985-08-06",2,25000,875.00000000000011,25875]
["Caracio","Terry","Sales","1994-08-09",2,25000,875.00000000000011,25875]
["Feldgus","Ernest","Sales","1978-09-28",2,24000,840.00000000000011,24840]
["Killough","Frank","Sales","1980-09-01",7,45000,1575.0000000000002,46575]
["Weinstein","Perry","Sales","1975-03-12",3,32000,1120,33120]

{"sheet":"Employee Totals","index":5,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Worldwide Sporting Goods"]
["Employee Information"]
[]
[]
["Department","Salary","Raise","New Salary"]
["Administration",{"$f":"SUM(Administration!F6:F10)","v":139000},{"$f":"SUM(Administration!G6:G10)","v":4865.0000000000009},{"$f":"+B6+C6","v":143865}]
["Development",{"$f":"SUM(D_Salary)","v":131000},{"$f":"SUM(D_Raise)","v":4585},{"$f":"+B7+C7","v":135585}]
["Production",{"$f":"SUM(P_Salary)","v":346000},{"$f":"SUM(P_Raise)","v":12110},{"$f":"+B8+C8","v":358110}]
["Sales",{"$f":"SUM(S_Salary)","v":298000},{"$f":"SUM(S_Raise)","v":10430.000000000002},{"$f":"+B9+C9","v":308430}]

{"sheet":"Sheet6","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet7","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet8","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}